<?xml version="1.0" encoding="ascii"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
          "DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
  <title>src.input.pg_manager</title>
  <link rel="stylesheet" href="epydoc.css" type="text/css" />
  <script type="text/javascript" src="epydoc.js"></script>
</head>

<body bgcolor="white" text="black" link="blue" vlink="#204080"
      alink="#204080">
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="src-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            >ttrq4fleet - Petrina Papazek</th>
          </tr></table></th>
  </tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="100%">
      <span class="breadcrumbs">
        <a href="src-module.html">Package&nbsp;src</a> ::
        <a href="src.input-module.html">Package&nbsp;input</a> ::
        Module&nbsp;pg_manager
      </span>
    </td>
    <td>
      <table cellpadding="0" cellspacing="0">
        <!-- hide/show private -->
        <tr><td align="right"><span class="options">[<a href="javascript:void(0);" class="privatelink"
    onclick="toggle_private();">hide&nbsp;private</a>]</span></td></tr>
        <tr><td align="right"><span class="options"
            >[<a href="frames.html" target="_top">frames</a
            >]&nbsp;|&nbsp;<a href="src.input.pg_manager-pysrc.html"
            target="_top">no&nbsp;frames</a>]</span></td></tr>
      </table>
    </td>
  </tr>
</table>
<h1 class="epydoc">Source Code for <a href="src.input.pg_manager-module.html">Module src.input.pg_manager</a></h1>
<pre class="py-src">
<a name="L1"></a><tt class="py-lineno">  1</tt>  <tt class="py-line"><tt class="py-docstring">'''</tt> </tt>
<a name="L2"></a><tt class="py-lineno">  2</tt>  <tt class="py-line"><tt class="py-docstring">Created on Aug 17, 2012</tt> </tt>
<a name="L3"></a><tt class="py-lineno">  3</tt>  <tt class="py-line"><tt class="py-docstring"></tt> </tt>
<a name="L4"></a><tt class="py-lineno">  4</tt>  <tt class="py-line"><tt class="py-docstring">@author: petrina</tt> </tt>
<a name="L5"></a><tt class="py-lineno">  5</tt>  <tt class="py-line"><tt class="py-docstring">'''</tt> </tt>
<a name="L6"></a><tt class="py-lineno">  6</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-0" class="py-name" targets="Module src.input.db_manager=src.input.db_manager-module.html"><a title="src.input.db_manager" class="py-name" href="#" onclick="return doclink('link-0', 'db_manager', 'link-0');">db_manager</a></tt> <tt class="py-keyword">import</tt> <tt class="py-op">*</tt> </tt>
<a name="L7"></a><tt class="py-lineno">  7</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">psycopg2</tt> </tt>
<a name="L8"></a><tt class="py-lineno">  8</tt>  <tt class="py-line"><tt class="py-keyword">from</tt> <tt id="link-1" class="py-name" targets="Package src.error=src.error-module.html"><a title="src.error" class="py-name" href="#" onclick="return doclink('link-1', 'error', 'link-1');">error</a></tt><tt class="py-op">.</tt><tt id="link-2" class="py-name" targets="Module src.error.exceptions=src.error.exceptions-module.html"><a title="src.error.exceptions" class="py-name" href="#" onclick="return doclink('link-2', 'exceptions', 'link-2');">exceptions</a></tt> <tt class="py-keyword">import</tt> <tt class="py-op">*</tt> </tt>
<a name="L9"></a><tt class="py-lineno">  9</tt>  <tt class="py-line"><tt class="py-keyword">import</tt> <tt class="py-name">logging</tt> </tt>
<a name="L10"></a><tt class="py-lineno"> 10</tt>  <tt class="py-line"> </tt>
<a name="L11"></a><tt class="py-lineno"> 11</tt>  <tt class="py-line"> </tt>
<a name="Pg_manager"></a><div id="Pg_manager-def"><a name="L12"></a><tt class="py-lineno"> 12</tt> <a class="py-toggle" href="#" id="Pg_manager-toggle" onclick="return toggle('Pg_manager');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html">Pg_manager</a><tt class="py-op">(</tt><tt class="py-base-class">DB_manager</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="Pg_manager-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="Pg_manager-expanded"><a name="L13"></a><tt class="py-lineno"> 13</tt>  <tt class="py-line">    <tt class="py-docstring">'''</tt> </tt>
<a name="L14"></a><tt class="py-lineno"> 14</tt>  <tt class="py-line"><tt class="py-docstring">    This class manages the connection to a Postgres-database</tt> </tt>
<a name="L15"></a><tt class="py-lineno"> 15</tt>  <tt class="py-line"><tt class="py-docstring">    '''</tt> </tt>
<a name="L16"></a><tt class="py-lineno"> 16</tt>  <tt class="py-line"> </tt>
<a name="L17"></a><tt class="py-lineno"> 17</tt>  <tt class="py-line"> </tt>
<a name="Pg_manager.__init__"></a><div id="Pg_manager.__init__-def"><a name="L18"></a><tt class="py-lineno"> 18</tt> <a class="py-toggle" href="#" id="Pg_manager.__init__-toggle" onclick="return toggle('Pg_manager.__init__');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html#__init__">__init__</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">dbparams</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="Pg_manager.__init__-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Pg_manager.__init__-expanded"><a name="L19"></a><tt class="py-lineno"> 19</tt>  <tt class="py-line">        <tt class="py-docstring">'''</tt> </tt>
<a name="L20"></a><tt class="py-lineno"> 20</tt>  <tt class="py-line"><tt class="py-docstring">        @param dbparams: parameters for the connection</tt> </tt>
<a name="L21"></a><tt class="py-lineno"> 21</tt>  <tt class="py-line"><tt class="py-docstring">        '''</tt> </tt>
<a name="L22"></a><tt class="py-lineno"> 22</tt>  <tt class="py-line">         </tt>
<a name="L23"></a><tt class="py-lineno"> 23</tt>  <tt class="py-line">        <tt id="link-3" class="py-name" targets="Class src.input.db_manager.DB_manager=src.input.db_manager.DB_manager-class.html"><a title="src.input.db_manager.DB_manager" class="py-name" href="#" onclick="return doclink('link-3', 'DB_manager', 'link-3');">DB_manager</a></tt><tt class="py-op">.</tt><tt id="link-4" class="py-name" targets="Method src.configuration.Default_config.__init__()=src.configuration.Default_config-class.html#__init__,Method src.configuration.config.Config.__init__()=src.configuration.config.Config-class.html#__init__,Method src.configuration.default_config.Default_config.__init__()=src.configuration.default_config.Default_config-class.html#__init__,Method src.datastructure.agg_record.Agg_record.__init__()=src.datastructure.agg_record.Agg_record-class.html#__init__,Method src.datastructure.interval_list.Interval_list.__init__()=src.datastructure.interval_list.Interval_list-class.html#__init__,Method src.datastructure.link.Link.__init__()=src.datastructure.link.Link-class.html#__init__,Method src.datastructure.linkset.Linkset.__init__()=src.datastructure.linkset.Linkset-class.html#__init__,Method src.datastructure.record_list.Record_list.__init__()=src.datastructure.record_list.Record_list-class.html#__init__,Method src.datastructure.result.Result.__init__()=src.datastructure.result.Result-class.html#__init__,Method src.datastructure.result_value.Result_value.__init__()=src.datastructure.result_value.Result_value-class.html#__init__,Method src.error.data_exceptions.Data_exception.__init__()=src.error.data_exceptions.Data_exception-class.html#__init__,Method src.error.data_exceptions.Link_exception.__init__()=src.error.data_exceptions.Link_exception-class.html#__init__,Method src.error.data_exceptions.Linkset_exception.__init__()=src.error.data_exceptions.Linkset_exception-class.html#__init__,Method src.error.data_exceptions.Record_exception.__init__()=src.error.data_exceptions.Record_exception-class.html#__init__,Method src.error.exceptions.Config_exception.__init__()=src.error.exceptions.Config_exception-class.html#__init__,Method src.error.exceptions.DB_connection_exception.__init__()=src.error.exceptions.DB_connection_exception-class.html#__init__,Method src.error.exceptions.Import_exception.__init__()=src.error.exceptions.Import_exception-class.html#__init__,Method src.error.exceptions.Indicator_exception.__init__()=src.error.exceptions.Indicator_exception-class.html#__init__,Method src.error.log_manager.Log_manager.__init__()=src.error.log_manager.Log_manager-class.html#__init__,Method src.error.output_exceptions.CSV_exception.__init__()=src.error.output_exceptions.CSV_exception-class.html#__init__,Method src.error.output_exceptions.Output_exception.__init__()=src.error.output_exceptions.Output_exception-class.html#__init__,Method src.error.output_exceptions.Plot_exception.__init__()=src.error.output_exceptions.Plot_exception-class.html#__init__,Method src.input.db_manager.DB_manager.__init__()=src.input.db_manager.DB_manager-class.html#__init__,Method src.input.db_params.DB_params.__init__()=src.input.db_params.DB_params-class.html#__init__,Method src.input.import_agg_FLEET.Import_agg_FLEET.__init__()=src.input.import_agg_FLEET.Import_agg_FLEET-class.html#__init__,Method src.input.import_data.Import_data.__init__()=src.input.import_data.Import_data-class.html#__init__,Method src.input.import_links.Import_links.__init__()=src.input.import_links.Import_links-class.html#__init__,Method src.input.import_timeseries.Import_timeseries.__init__()=src.input.import_timeseries.Import_timeseries-class.html#__init__,Method src.input.input_process.Input_process.__init__()=src.input.input_process.Input_process-class.html#__init__,Method src.input.pg_manager.Pg_manager.__init__()=src.input.pg_manager.Pg_manager-class.html#__init__,Method src.output.csv_export.CSV_export.__init__()=src.output.csv_export.CSV_export-class.html#__init__,Method src.output.export.Export.__init__()=src.output.export.Export-class.html#__init__,Method src.output.link_outputmanager.Link_output_manager.__init__()=src.output.link_outputmanager.Link_output_manager-class.html#__init__,Method src.output.network_outputmanager.Network_output_manager.__init__()=src.output.network_outputmanager.Network_output_manager-class.html#__init__,Method src.output.outputmanager.Output_manager.__init__()=src.output.outputmanager.Output_manager-class.html#__init__,Method src.output.plot.Plot.__init__()=src.output.plot.Plot-class.html#__init__,Method src.output.webserver.Webserver.__init__()=src.output.webserver.Webserver-class.html#__init__,Method src.processing.accuracy_indicator.Accuracy_indicator.__init__()=src.processing.accuracy_indicator.Accuracy_indicator-class.html#__init__,Method src.processing.buffer_index.Buffer_index.__init__()=src.processing.buffer_index.Buffer_index-class.html#__init__,Method src.processing.buffer_speed.Buffer_speed.__init__()=src.processing.buffer_speed.Buffer_speed-class.html#__init__,Method src.processing.buffer_speed_index.Buffer_speed_index.__init__()=src.processing.buffer_speed_index.Buffer_speed_index-class.html#__init__,Method src.processing.buffer_time.Buffer_time.__init__()=src.processing.buffer_time.Buffer_time-class.html#__init__,Method src.processing.completeness.Completeness.__init__()=src.processing.completeness.Completeness-class.html#__init__,Method src.processing.correlation_coefficient.Correlation_coefficient.__init__()=src.processing.correlation_coefficient.Correlation_coefficient-class.html#__init__,Method src.processing.indicator.Indicator.__init__()=src.processing.indicator.Indicator-class.html#__init__,Method src.processing.indicatorset.Indicatorset.__init__()=src.processing.indicatorset.Indicatorset-class.html#__init__,Method src.processing.link_indicator.Link_indicator.__init__()=src.processing.link_indicator.Link_indicator-class.html#__init__,Method src.processing.link_indicatorset.Link_indicatorset.__init__()=src.processing.link_indicatorset.Link_indicatorset-class.html#__init__,Method src.processing.link_processor.Link_processor.__init__()=src.processing.link_processor.Link_processor-class.html#__init__,Method src.processing.mean_error.Mean_error.__init__()=src.processing.mean_error.Mean_error-class.html#__init__,Method src.processing.mean_squared_error.Mean_squared_error.__init__()=src.processing.mean_squared_error.Mean_squared_error-class.html#__init__,Method src.processing.network_completeness.Network_completeness.__init__()=src.processing.network_completeness.Network_completeness-class.html#__init__,Method src.processing.network_indicator.Network_indicator.__init__()=src.processing.network_indicator.Network_indicator-class.html#__init__,Method src.processing.network_indicatorset.Network_indicatorset.__init__()=src.processing.network_indicatorset.Network_indicatorset-class.html#__init__,Method src.processing.network_processor.Network_processor.__init__()=src.processing.network_processor.Network_processor-class.html#__init__,Method src.processing.planning_speed.Planning_speed.__init__()=src.processing.planning_speed.Planning_speed-class.html#__init__,Method src.processing.planning_speed_index.Planning_speed_index.__init__()=src.processing.planning_speed_index.Planning_speed_index-class.html#__init__,Method src.processing.planning_time.Planning_time.__init__()=src.processing.planning_time.Planning_time-class.html#__init__,Method src.processing.planning_time_index.Planning_time_index.__init__()=src.processing.planning_time_index.Planning_time_index-class.html#__init__,Method src.processing.processor.Processor.__init__()=src.processing.processor.Processor-class.html#__init__,Method src.processing.reliability_indicator.Reliability_indicator.__init__()=src.processing.reliability_indicator.Reliability_indicator-class.html#__init__,Method src.processing.reliability_speed_indicator.Reliability_speed_indicator.__init__()=src.processing.reliability_speed_indicator.Reliability_speed_indicator-class.html#__init__,Method src.processing.reliability_tt_indicator.Reliability_tt_indicator.__init__()=src.processing.reliability_tt_indicator.Reliability_tt_indicator-class.html#__init__,Method src.processing.variation_speeds.Variation_speeds.__init__()=src.processing.variation_speeds.Variation_speeds-class.html#__init__,Method src.processing.variation_tt.Variation_tt.__init__()=src.processing.variation_tt.Variation_tt-class.html#__init__"><a title="src.configuration.Default_config.__init__
src.configuration.config.Config.__init__
src.configuration.default_config.Default_config.__init__
src.datastructure.agg_record.Agg_record.__init__
src.datastructure.interval_list.Interval_list.__init__
src.datastructure.link.Link.__init__
src.datastructure.linkset.Linkset.__init__
src.datastructure.record_list.Record_list.__init__
src.datastructure.result.Result.__init__
src.datastructure.result_value.Result_value.__init__
src.error.data_exceptions.Data_exception.__init__
src.error.data_exceptions.Link_exception.__init__
src.error.data_exceptions.Linkset_exception.__init__
src.error.data_exceptions.Record_exception.__init__
src.error.exceptions.Config_exception.__init__
src.error.exceptions.DB_connection_exception.__init__
src.error.exceptions.Import_exception.__init__
src.error.exceptions.Indicator_exception.__init__
src.error.log_manager.Log_manager.__init__
src.error.output_exceptions.CSV_exception.__init__
src.error.output_exceptions.Output_exception.__init__
src.error.output_exceptions.Plot_exception.__init__
src.input.db_manager.DB_manager.__init__
src.input.db_params.DB_params.__init__
src.input.import_agg_FLEET.Import_agg_FLEET.__init__
src.input.import_data.Import_data.__init__
src.input.import_links.Import_links.__init__
src.input.import_timeseries.Import_timeseries.__init__
src.input.input_process.Input_process.__init__
src.input.pg_manager.Pg_manager.__init__
src.output.csv_export.CSV_export.__init__
src.output.export.Export.__init__
src.output.link_outputmanager.Link_output_manager.__init__
src.output.network_outputmanager.Network_output_manager.__init__
src.output.outputmanager.Output_manager.__init__
src.output.plot.Plot.__init__
src.output.webserver.Webserver.__init__
src.processing.accuracy_indicator.Accuracy_indicator.__init__
src.processing.buffer_index.Buffer_index.__init__
src.processing.buffer_speed.Buffer_speed.__init__
src.processing.buffer_speed_index.Buffer_speed_index.__init__
src.processing.buffer_time.Buffer_time.__init__
src.processing.completeness.Completeness.__init__
src.processing.correlation_coefficient.Correlation_coefficient.__init__
src.processing.indicator.Indicator.__init__
src.processing.indicatorset.Indicatorset.__init__
src.processing.link_indicator.Link_indicator.__init__
src.processing.link_indicatorset.Link_indicatorset.__init__
src.processing.link_processor.Link_processor.__init__
src.processing.mean_error.Mean_error.__init__
src.processing.mean_squared_error.Mean_squared_error.__init__
src.processing.network_completeness.Network_completeness.__init__
src.processing.network_indicator.Network_indicator.__init__
src.processing.network_indicatorset.Network_indicatorset.__init__
src.processing.network_processor.Network_processor.__init__
src.processing.planning_speed.Planning_speed.__init__
src.processing.planning_speed_index.Planning_speed_index.__init__
src.processing.planning_time.Planning_time.__init__
src.processing.planning_time_index.Planning_time_index.__init__
src.processing.processor.Processor.__init__
src.processing.reliability_indicator.Reliability_indicator.__init__
src.processing.reliability_speed_indicator.Reliability_speed_indicator.__init__
src.processing.reliability_tt_indicator.Reliability_tt_indicator.__init__
src.processing.variation_speeds.Variation_speeds.__init__
src.processing.variation_tt.Variation_tt.__init__" class="py-name" href="#" onclick="return doclink('link-4', '__init__', 'link-4');">__init__</a></tt><tt class="py-op">(</tt><tt class="py-name">self</tt><tt class="py-op">,</tt> <tt class="py-name">dbparams</tt><tt class="py-op">)</tt>  </tt>
<a name="L24"></a><tt class="py-lineno"> 24</tt>  <tt class="py-line">         </tt>
<a name="L25"></a><tt class="py-lineno"> 25</tt>  <tt class="py-line">        <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">debug</tt><tt class="py-op">(</tt><tt class="py-string">"Pg_manager: created Pg_manager"</tt><tt class="py-op">)</tt> </tt>
</div><a name="L26"></a><tt class="py-lineno"> 26</tt>  <tt class="py-line">         </tt>
<a name="L27"></a><tt class="py-lineno"> 27</tt>  <tt class="py-line">     </tt>
<a name="L28"></a><tt class="py-lineno"> 28</tt>  <tt class="py-line">    <tt class="py-comment">#----------------------public methods of the class-------------------------       </tt> </tt>
<a name="L29"></a><tt class="py-lineno"> 29</tt>  <tt class="py-line">        </tt>
<a name="Pg_manager.test_db"></a><div id="Pg_manager.test_db-def"><a name="L30"></a><tt class="py-lineno"> 30</tt> <a class="py-toggle" href="#" id="Pg_manager.test_db-toggle" onclick="return toggle('Pg_manager.test_db');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html#test_db">test_db</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">)</tt><tt class="py-op">:</tt>  </tt>
</div><a name="L31"></a><tt class="py-lineno"> 31</tt>  <tt class="py-line">        <tt class="py-docstring">'''</tt> </tt>
<a name="L32"></a><tt class="py-lineno"> 32</tt>  <tt class="py-line"><tt class="py-docstring">        This method tests the database connection. </tt> </tt>
<a name="L33"></a><tt class="py-lineno"> 33</tt>  <tt class="py-line"><tt class="py-docstring">        </tt> </tt>
<a name="L34"></a><tt class="py-lineno"> 34</tt>  <tt class="py-line"><tt class="py-docstring">        If the database connection works the db-version is printed.</tt> </tt>
<a name="L35"></a><tt class="py-lineno"> 35</tt>  <tt class="py-line"><tt class="py-docstring">        '''</tt> </tt>
<a name="L36"></a><tt class="py-lineno"> 36</tt>  <tt class="py-line"> </tt>
<a name="L37"></a><tt class="py-lineno"> 37</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L38"></a><tt class="py-lineno"> 38</tt>  <tt class="py-line">            <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">info</tt><tt class="py-op">(</tt><tt class="py-string">"trying to test the database connection (pg)"</tt><tt class="py-op">)</tt> </tt>
<a name="L39"></a><tt class="py-lineno"> 39</tt>  <tt class="py-line">             </tt>
<a name="L40"></a><tt class="py-lineno"> 40</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-5" class="py-name" targets="Method src.input.db_manager.DB_manager.connect()=src.input.db_manager.DB_manager-class.html#connect,Method src.input.pg_manager.Pg_manager.connect()=src.input.pg_manager.Pg_manager-class.html#connect"><a title="src.input.db_manager.DB_manager.connect
src.input.pg_manager.Pg_manager.connect" class="py-name" href="#" onclick="return doclink('link-5', 'connect', 'link-5');">connect</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt>  </tt>
<a name="L41"></a><tt class="py-lineno"> 41</tt>  <tt class="py-line">            <tt class="py-name">cur</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">_con</tt><tt class="py-op">.</tt><tt class="py-name">cursor</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L42"></a><tt class="py-lineno"> 42</tt>  <tt class="py-line">            <tt class="py-name">cur</tt><tt class="py-op">.</tt><tt class="py-name">execute</tt><tt class="py-op">(</tt><tt class="py-string">'SELECT version()'</tt><tt class="py-op">)</tt>           </tt>
<a name="L43"></a><tt class="py-lineno"> 43</tt>  <tt class="py-line">            <tt class="py-name">ver</tt> <tt class="py-op">=</tt> <tt class="py-name">cur</tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L44"></a><tt class="py-lineno"> 44</tt>  <tt class="py-line">            <tt class="py-keyword">print</tt> <tt class="py-name">ver</tt>     </tt>
<a name="L45"></a><tt class="py-lineno"> 45</tt>  <tt class="py-line">             </tt>
<a name="L46"></a><tt class="py-lineno"> 46</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt> <tt class="py-name">psycopg2</tt><tt class="py-op">.</tt><tt class="py-name">DatabaseError</tt><tt class="py-op">,</tt> <tt class="py-name">e</tt><tt class="py-op">:</tt> </tt>
<a name="L47"></a><tt class="py-lineno"> 47</tt>  <tt class="py-line">            <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt id="link-6" class="py-name"><a title="src.error" class="py-name" href="#" onclick="return doclink('link-6', 'error', 'link-1');">error</a></tt><tt class="py-op">(</tt><tt class="py-string">"The connection to the database is not possible: "</tt> <tt class="py-op">+</tt> <tt class="py-name">e</tt><tt class="py-op">.</tt><tt id="link-7" class="py-name" targets="Method src.datastructure.agg_record.Agg_record.__str__()=src.datastructure.agg_record.Agg_record-class.html#__str__,Method src.datastructure.link.Link.__str__()=src.datastructure.link.Link-class.html#__str__,Method src.datastructure.result_value.Result_value.__str__()=src.datastructure.result_value.Result_value-class.html#__str__,Method src.error.data_exceptions.Data_exception.__str__()=src.error.data_exceptions.Data_exception-class.html#__str__,Method src.error.exceptions.Config_exception.__str__()=src.error.exceptions.Config_exception-class.html#__str__,Method src.error.exceptions.Import_exception.__str__()=src.error.exceptions.Import_exception-class.html#__str__,Method src.error.exceptions.Indicator_exception.__str__()=src.error.exceptions.Indicator_exception-class.html#__str__,Method src.error.output_exceptions.Output_exception.__str__()=src.error.output_exceptions.Output_exception-class.html#__str__,Method src.input.db_params.DB_params.__str__()=src.input.db_params.DB_params-class.html#__str__"><a title="src.datastructure.agg_record.Agg_record.__str__
src.datastructure.link.Link.__str__
src.datastructure.result_value.Result_value.__str__
src.error.data_exceptions.Data_exception.__str__
src.error.exceptions.Config_exception.__str__
src.error.exceptions.Import_exception.__str__
src.error.exceptions.Indicator_exception.__str__
src.error.output_exceptions.Output_exception.__str__
src.input.db_params.DB_params.__str__" class="py-name" href="#" onclick="return doclink('link-7', '__str__', 'link-7');">__str__</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> <tt class="py-op">)</tt>     </tt>
<a name="L48"></a><tt class="py-lineno"> 48</tt>  <tt class="py-line">              </tt>
<a name="L49"></a><tt class="py-lineno"> 49</tt>  <tt class="py-line">        <tt class="py-keyword">finally</tt><tt class="py-op">:</tt> </tt>
<a name="L50"></a><tt class="py-lineno"> 50</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-8" class="py-name" targets="Method src.input.db_manager.DB_manager.disconnect()=src.input.db_manager.DB_manager-class.html#disconnect,Method src.input.pg_manager.Pg_manager.disconnect()=src.input.pg_manager.Pg_manager-class.html#disconnect"><a title="src.input.db_manager.DB_manager.disconnect
src.input.pg_manager.Pg_manager.disconnect" class="py-name" href="#" onclick="return doclink('link-8', 'disconnect', 'link-8');">disconnect</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
</div><a name="L51"></a><tt class="py-lineno"> 51</tt>  <tt class="py-line">             </tt>
<a name="L52"></a><tt class="py-lineno"> 52</tt>  <tt class="py-line">         </tt>
<a name="Pg_manager.connect"></a><div id="Pg_manager.connect-def"><a name="L53"></a><tt class="py-lineno"> 53</tt> <a class="py-toggle" href="#" id="Pg_manager.connect-toggle" onclick="return toggle('Pg_manager.connect');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html#connect">connect</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="Pg_manager.connect-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Pg_manager.connect-expanded"><a name="L54"></a><tt class="py-lineno"> 54</tt>  <tt class="py-line">        <tt class="py-docstring">'''</tt> </tt>
<a name="L55"></a><tt class="py-lineno"> 55</tt>  <tt class="py-line"><tt class="py-docstring">        Opens a new connection to the database using the database parameters.</tt> </tt>
<a name="L56"></a><tt class="py-lineno"> 56</tt>  <tt class="py-line"><tt class="py-docstring">        </tt> </tt>
<a name="L57"></a><tt class="py-lineno"> 57</tt>  <tt class="py-line"><tt class="py-docstring">        If the connection fails a DB_connection_exception is raised.</tt> </tt>
<a name="L58"></a><tt class="py-lineno"> 58</tt>  <tt class="py-line"><tt class="py-docstring">        '''</tt> </tt>
<a name="L59"></a><tt class="py-lineno"> 59</tt>  <tt class="py-line">         </tt>
<a name="L60"></a><tt class="py-lineno"> 60</tt>  <tt class="py-line">        <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">_con</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt> </tt>
<a name="L61"></a><tt class="py-lineno"> 61</tt>  <tt class="py-line">         </tt>
<a name="L62"></a><tt class="py-lineno"> 62</tt>  <tt class="py-line">        <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt>
<a name="L63"></a><tt class="py-lineno"> 63</tt>  <tt class="py-line">            <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">debug</tt><tt class="py-op">(</tt><tt class="py-string">"Pg_manager: trying to connect to the database"</tt><tt class="py-op">)</tt> </tt>
<a name="L64"></a><tt class="py-lineno"> 64</tt>  <tt class="py-line">             </tt>
<a name="L65"></a><tt class="py-lineno"> 65</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">_con</tt> <tt class="py-op">=</tt> <tt class="py-name">psycopg2</tt><tt class="py-op">.</tt><tt id="link-9" class="py-name"><a title="src.input.db_manager.DB_manager.connect
src.input.pg_manager.Pg_manager.connect" class="py-name" href="#" onclick="return doclink('link-9', 'connect', 'link-5');">connect</a></tt><tt class="py-op">(</tt><tt class="py-name">database</tt><tt class="py-op">=</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">dbparams</tt><tt class="py-op">.</tt><tt id="link-10" class="py-name" targets="Variable src.configuration.default_config.Default_config.databasename=src.configuration.default_config.Default_config-class.html#databasename,Variable src.input.db_params.DB_params.databasename=src.input.db_params.DB_params-class.html#databasename"><a title="src.configuration.default_config.Default_config.databasename
src.input.db_params.DB_params.databasename" class="py-name" href="#" onclick="return doclink('link-10', 'databasename', 'link-10');">databasename</a></tt><tt class="py-op">,</tt>  </tt>
<a name="L66"></a><tt class="py-lineno"> 66</tt>  <tt class="py-line">                                         <tt class="py-name">user</tt><tt class="py-op">=</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">dbparams</tt><tt class="py-op">.</tt><tt id="link-11" class="py-name" targets="Variable src.configuration.default_config.Default_config.username=src.configuration.default_config.Default_config-class.html#username,Variable src.input.db_params.DB_params.username=src.input.db_params.DB_params-class.html#username"><a title="src.configuration.default_config.Default_config.username
src.input.db_params.DB_params.username" class="py-name" href="#" onclick="return doclink('link-11', 'username', 'link-11');">username</a></tt><tt class="py-op">,</tt> </tt>
<a name="L67"></a><tt class="py-lineno"> 67</tt>  <tt class="py-line">                                         <tt id="link-12" class="py-name" targets="Variable src.input.db_params.DB_params.host=src.input.db_params.DB_params-class.html#host"><a title="src.input.db_params.DB_params.host" class="py-name" href="#" onclick="return doclink('link-12', 'host', 'link-12');">host</a></tt><tt class="py-op">=</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">dbparams</tt><tt class="py-op">.</tt><tt id="link-13" class="py-name"><a title="src.input.db_params.DB_params.host" class="py-name" href="#" onclick="return doclink('link-13', 'host', 'link-12');">host</a></tt><tt class="py-op">,</tt> </tt>
<a name="L68"></a><tt class="py-lineno"> 68</tt>  <tt class="py-line">                                         <tt id="link-14" class="py-name" targets="Variable src.configuration.default_config.Default_config.password=src.configuration.default_config.Default_config-class.html#password,Variable src.input.db_params.DB_params.password=src.input.db_params.DB_params-class.html#password"><a title="src.configuration.default_config.Default_config.password
src.input.db_params.DB_params.password" class="py-name" href="#" onclick="return doclink('link-14', 'password', 'link-14');">password</a></tt><tt class="py-op">=</tt><tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">dbparams</tt><tt class="py-op">.</tt><tt id="link-15" class="py-name"><a title="src.configuration.default_config.Default_config.password
src.input.db_params.DB_params.password" class="py-name" href="#" onclick="return doclink('link-15', 'password', 'link-14');">password</a></tt><tt class="py-op">)</tt>          </tt>
<a name="L69"></a><tt class="py-lineno"> 69</tt>  <tt class="py-line">         </tt>
<a name="L70"></a><tt class="py-lineno"> 70</tt>  <tt class="py-line">        <tt class="py-keyword">except</tt> <tt class="py-name">psycopg2</tt><tt class="py-op">.</tt><tt class="py-name">DatabaseError</tt><tt class="py-op">,</tt> <tt class="py-name">e</tt><tt class="py-op">:</tt> </tt>
<a name="L71"></a><tt class="py-lineno"> 71</tt>  <tt class="py-line">            <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt id="link-16" class="py-name"><a title="src.error" class="py-name" href="#" onclick="return doclink('link-16', 'error', 'link-1');">error</a></tt><tt class="py-op">(</tt><tt class="py-string">"Pg_manager: database connection error: "</tt> <tt class="py-op">+</tt> <tt class="py-name">e</tt><tt class="py-op">.</tt><tt id="link-17" class="py-name"><a title="src.datastructure.agg_record.Agg_record.__str__
src.datastructure.link.Link.__str__
src.datastructure.result_value.Result_value.__str__
src.error.data_exceptions.Data_exception.__str__
src.error.exceptions.Config_exception.__str__
src.error.exceptions.Import_exception.__str__
src.error.exceptions.Indicator_exception.__str__
src.error.output_exceptions.Output_exception.__str__
src.input.db_params.DB_params.__str__" class="py-name" href="#" onclick="return doclink('link-17', '__str__', 'link-7');">__str__</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt>
<a name="L72"></a><tt class="py-lineno"> 72</tt>  <tt class="py-line">            <tt class="py-keyword">raise</tt> <tt id="link-18" class="py-name" targets="Class src.error.exceptions.DB_connection_exception=src.error.exceptions.DB_connection_exception-class.html"><a title="src.error.exceptions.DB_connection_exception" class="py-name" href="#" onclick="return doclink('link-18', 'DB_connection_exception', 'link-18');">DB_connection_exception</a></tt><tt class="py-op">(</tt><tt class="py-name">e</tt><tt class="py-op">.</tt><tt id="link-19" class="py-name"><a title="src.datastructure.agg_record.Agg_record.__str__
src.datastructure.link.Link.__str__
src.datastructure.result_value.Result_value.__str__
src.error.data_exceptions.Data_exception.__str__
src.error.exceptions.Config_exception.__str__
src.error.exceptions.Import_exception.__str__
src.error.exceptions.Indicator_exception.__str__
src.error.output_exceptions.Output_exception.__str__
src.input.db_params.DB_params.__str__" class="py-name" href="#" onclick="return doclink('link-19', '__str__', 'link-7');">__str__</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">)</tt>   </tt>
</div><a name="L73"></a><tt class="py-lineno"> 73</tt>  <tt class="py-line">                     </tt>
<a name="L74"></a><tt class="py-lineno"> 74</tt>  <tt class="py-line"> </tt>
<a name="Pg_manager.select"></a><div id="Pg_manager.select-def"><a name="L75"></a><tt class="py-lineno"> 75</tt> <a class="py-toggle" href="#" id="Pg_manager.select-toggle" onclick="return toggle('Pg_manager.select');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html#select">select</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">table</tt><tt class="py-op">,</tt> <tt class="py-param">fields</tt> <tt class="py-op">=</tt> <tt class="py-string">'*'</tt><tt class="py-op">,</tt> <tt class="py-param">clause</tt> <tt class="py-op">=</tt> <tt class="py-string">''</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="Pg_manager.select-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Pg_manager.select-expanded"><a name="L76"></a><tt class="py-lineno"> 76</tt>  <tt class="py-line">        <tt class="py-docstring">'''</tt> </tt>
<a name="L77"></a><tt class="py-lineno"> 77</tt>  <tt class="py-line"><tt class="py-docstring">        Sends a select query to the database and returns the rows.</tt> </tt>
<a name="L78"></a><tt class="py-lineno"> 78</tt>  <tt class="py-line"><tt class="py-docstring">        @param table: name of the table or view in the database as string</tt> </tt>
<a name="L79"></a><tt class="py-lineno"> 79</tt>  <tt class="py-line"><tt class="py-docstring">        @param fields: selected fields (default: '*', i.e. all fields)</tt> </tt>
<a name="L80"></a><tt class="py-lineno"> 80</tt>  <tt class="py-line"><tt class="py-docstring">        @param clause: where-clause as string</tt> </tt>
<a name="L81"></a><tt class="py-lineno"> 81</tt>  <tt class="py-line"><tt class="py-docstring">        @return: rows (list&lt;list&gt;)</tt> </tt>
<a name="L82"></a><tt class="py-lineno"> 82</tt>  <tt class="py-line"><tt class="py-docstring">        '''</tt> </tt>
<a name="L83"></a><tt class="py-lineno"> 83</tt>  <tt class="py-line">         </tt>
<a name="L84"></a><tt class="py-lineno"> 84</tt>  <tt class="py-line">        <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">debug</tt><tt class="py-op">(</tt><tt class="py-string">"Pg_manager: building select-query"</tt><tt class="py-op">)</tt> </tt>
<a name="L85"></a><tt class="py-lineno"> 85</tt>  <tt class="py-line">        <tt class="py-comment"># create a field string</tt> </tt>
<a name="L86"></a><tt class="py-lineno"> 86</tt>  <tt class="py-line">        <tt class="py-name">fields_str</tt> <tt class="py-op">=</tt> <tt class="py-string">''</tt> </tt>
<a name="L87"></a><tt class="py-lineno"> 87</tt>  <tt class="py-line">         </tt>
<a name="L88"></a><tt class="py-lineno"> 88</tt>  <tt class="py-line">        <tt class="py-comment"># there are more fields</tt> </tt>
<a name="L89"></a><tt class="py-lineno"> 89</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">fields</tt><tt class="py-op">,</tt> <tt class="py-name">set</tt><tt class="py-op">)</tt> <tt class="py-keyword">or</tt> <tt class="py-name">isinstance</tt><tt class="py-op">(</tt><tt class="py-name">fields</tt><tt class="py-op">,</tt><tt class="py-name">list</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L90"></a><tt class="py-lineno"> 90</tt>  <tt class="py-line">            <tt class="py-name">nb_tables</tt> <tt class="py-op">=</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">fields</tt><tt class="py-op">)</tt> </tt>
<a name="L91"></a><tt class="py-lineno"> 91</tt>  <tt class="py-line">            <tt class="py-keyword">for</tt> <tt class="py-name">i</tt> <tt class="py-keyword">in</tt> <tt class="py-name">range</tt><tt class="py-op">(</tt><tt class="py-name">nb_tables</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
<a name="L92"></a><tt class="py-lineno"> 92</tt>  <tt class="py-line">                <tt class="py-name">fields_str</tt> <tt class="py-op">+=</tt> <tt class="py-name">fields</tt><tt class="py-op">[</tt><tt class="py-name">i</tt><tt class="py-op">]</tt><tt class="py-op">.</tt><tt id="link-20" class="py-name"><a title="src.datastructure.agg_record.Agg_record.__str__
src.datastructure.link.Link.__str__
src.datastructure.result_value.Result_value.__str__
src.error.data_exceptions.Data_exception.__str__
src.error.exceptions.Config_exception.__str__
src.error.exceptions.Import_exception.__str__
src.error.exceptions.Indicator_exception.__str__
src.error.output_exceptions.Output_exception.__str__
src.input.db_params.DB_params.__str__" class="py-name" href="#" onclick="return doclink('link-20', '__str__', 'link-7');">__str__</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L93"></a><tt class="py-lineno"> 93</tt>  <tt class="py-line">                 </tt>
<a name="L94"></a><tt class="py-lineno"> 94</tt>  <tt class="py-line">                <tt class="py-keyword">if</tt> <tt class="py-name">i</tt> <tt class="py-op">&lt;</tt> <tt class="py-name">nb_tables</tt> <tt class="py-op">-</tt> <tt class="py-number">1</tt><tt class="py-op">:</tt> </tt>
<a name="L95"></a><tt class="py-lineno"> 95</tt>  <tt class="py-line">                    <tt class="py-name">fields_str</tt> <tt class="py-op">+=</tt> <tt class="py-string">','</tt> </tt>
<a name="L96"></a><tt class="py-lineno"> 96</tt>  <tt class="py-line">                    </tt>
<a name="L97"></a><tt class="py-lineno"> 97</tt>  <tt class="py-line">        <tt class="py-comment"># just one field or *</tt> </tt>
<a name="L98"></a><tt class="py-lineno"> 98</tt>  <tt class="py-line">        <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt>
<a name="L99"></a><tt class="py-lineno"> 99</tt>  <tt class="py-line">            <tt class="py-name">fields_str</tt> <tt class="py-op">=</tt> <tt class="py-name">fields</tt><tt class="py-op">.</tt><tt id="link-21" class="py-name"><a title="src.datastructure.agg_record.Agg_record.__str__
src.datastructure.link.Link.__str__
src.datastructure.result_value.Result_value.__str__
src.error.data_exceptions.Data_exception.__str__
src.error.exceptions.Config_exception.__str__
src.error.exceptions.Import_exception.__str__
src.error.exceptions.Indicator_exception.__str__
src.error.output_exceptions.Output_exception.__str__
src.input.db_params.DB_params.__str__" class="py-name" href="#" onclick="return doclink('link-21', '__str__', 'link-7');">__str__</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L100"></a><tt class="py-lineno">100</tt>  <tt class="py-line">         </tt>
<a name="L101"></a><tt class="py-lineno">101</tt>  <tt class="py-line">        <tt class="py-comment"># build query like that: SELECT &lt;fields&gt; FROM &lt;table&gt;</tt> </tt>
<a name="L102"></a><tt class="py-lineno">102</tt>  <tt class="py-line">        <tt id="link-22" class="py-name" targets="Method src.input.pg_manager.Pg_manager.query()=src.input.pg_manager.Pg_manager-class.html#query"><a title="src.input.pg_manager.Pg_manager.query" class="py-name" href="#" onclick="return doclink('link-22', 'query', 'link-22');">query</a></tt> <tt class="py-op">=</tt> <tt class="py-string">"SELECT "</tt> <tt class="py-op">+</tt> <tt class="py-name">fields_str</tt> <tt class="py-op">+</tt> <tt class="py-string">" FROM "</tt> <tt class="py-op">+</tt> <tt class="py-name">table</tt><tt class="py-op">.</tt><tt id="link-23" class="py-name"><a title="src.datastructure.agg_record.Agg_record.__str__
src.datastructure.link.Link.__str__
src.datastructure.result_value.Result_value.__str__
src.error.data_exceptions.Data_exception.__str__
src.error.exceptions.Config_exception.__str__
src.error.exceptions.Import_exception.__str__
src.error.exceptions.Indicator_exception.__str__
src.error.output_exceptions.Output_exception.__str__
src.input.db_params.DB_params.__str__" class="py-name" href="#" onclick="return doclink('link-23', '__str__', 'link-7');">__str__</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt>  </tt>
<a name="L103"></a><tt class="py-lineno">103</tt>  <tt class="py-line">         </tt>
<a name="L104"></a><tt class="py-lineno">104</tt>  <tt class="py-line">        <tt class="py-comment"># where-clause</tt> </tt>
<a name="L105"></a><tt class="py-lineno">105</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">len</tt><tt class="py-op">(</tt><tt class="py-name">clause</tt><tt class="py-op">)</tt> <tt class="py-op">&gt;</tt> <tt class="py-number">0</tt><tt class="py-op">:</tt> </tt>
<a name="L106"></a><tt class="py-lineno">106</tt>  <tt class="py-line">            <tt id="link-24" class="py-name"><a title="src.input.pg_manager.Pg_manager.query" class="py-name" href="#" onclick="return doclink('link-24', 'query', 'link-22');">query</a></tt> <tt class="py-op">+=</tt> <tt class="py-string">" WHERE "</tt> <tt class="py-op">+</tt> <tt class="py-name">clause</tt>  </tt>
<a name="L107"></a><tt class="py-lineno">107</tt>  <tt class="py-line">         </tt>
<a name="L108"></a><tt class="py-lineno">108</tt>  <tt class="py-line">        <tt class="py-comment"># send query to db</tt> </tt>
<a name="L109"></a><tt class="py-lineno">109</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-25" class="py-name"><a title="src.input.pg_manager.Pg_manager.query" class="py-name" href="#" onclick="return doclink('link-25', 'query', 'link-22');">query</a></tt><tt class="py-op">(</tt><tt id="link-26" class="py-name"><a title="src.input.pg_manager.Pg_manager.query" class="py-name" href="#" onclick="return doclink('link-26', 'query', 'link-22');">query</a></tt><tt class="py-op">)</tt> </tt>
</div><a name="L110"></a><tt class="py-lineno">110</tt>  <tt class="py-line"> </tt>
<a name="L111"></a><tt class="py-lineno">111</tt>  <tt class="py-line"> </tt>
<a name="Pg_manager.query"></a><div id="Pg_manager.query-def"><a name="L112"></a><tt class="py-lineno">112</tt> <a class="py-toggle" href="#" id="Pg_manager.query-toggle" onclick="return toggle('Pg_manager.query');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html#query">query</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">query</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="Pg_manager.query-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Pg_manager.query-expanded"><a name="L113"></a><tt class="py-lineno">113</tt>  <tt class="py-line">        <tt class="py-docstring">'''</tt> </tt>
<a name="L114"></a><tt class="py-lineno">114</tt>  <tt class="py-line"><tt class="py-docstring">        Sends a given query (as string) to the database and returns the rows.</tt> </tt>
<a name="L115"></a><tt class="py-lineno">115</tt>  <tt class="py-line"><tt class="py-docstring">        </tt> </tt>
<a name="L116"></a><tt class="py-lineno">116</tt>  <tt class="py-line"><tt class="py-docstring">        @param query: query as string</tt> </tt>
<a name="L117"></a><tt class="py-lineno">117</tt>  <tt class="py-line"><tt class="py-docstring">        @return: rows (list&lt;list&gt;)</tt> </tt>
<a name="L118"></a><tt class="py-lineno">118</tt>  <tt class="py-line"><tt class="py-docstring">        '''</tt> </tt>
<a name="L119"></a><tt class="py-lineno">119</tt>  <tt class="py-line">         </tt>
<a name="L120"></a><tt class="py-lineno">120</tt>  <tt class="py-line">        <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">info</tt><tt class="py-op">(</tt><tt class="py-string">"Pg_manager: sending query to database '"</tt> <tt class="py-op">+</tt> <tt id="link-27" class="py-name"><a title="src.input.pg_manager.Pg_manager.query" class="py-name" href="#" onclick="return doclink('link-27', 'query', 'link-22');">query</a></tt> <tt class="py-op">+</tt> <tt class="py-string">"'"</tt><tt class="py-op">)</tt> </tt>
<a name="L121"></a><tt class="py-lineno">121</tt>  <tt class="py-line">         </tt>
<a name="L122"></a><tt class="py-lineno">122</tt>  <tt class="py-line">        <tt class="py-name">cur</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">_con</tt><tt class="py-op">.</tt><tt class="py-name">cursor</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L123"></a><tt class="py-lineno">123</tt>  <tt class="py-line">        <tt class="py-name">cur</tt><tt class="py-op">.</tt><tt class="py-name">execute</tt><tt class="py-op">(</tt><tt id="link-28" class="py-name"><a title="src.input.pg_manager.Pg_manager.query" class="py-name" href="#" onclick="return doclink('link-28', 'query', 'link-22');">query</a></tt><tt class="py-op">)</tt>        </tt>
<a name="L124"></a><tt class="py-lineno">124</tt>  <tt class="py-line">        <tt class="py-name">rows</tt> <tt class="py-op">=</tt> <tt class="py-name">cur</tt><tt class="py-op">.</tt><tt class="py-name">fetchall</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
<a name="L125"></a><tt class="py-lineno">125</tt>  <tt class="py-line"> </tt>
<a name="L126"></a><tt class="py-lineno">126</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">rows</tt> </tt>
</div><a name="L127"></a><tt class="py-lineno">127</tt>  <tt class="py-line"> </tt>
<a name="L128"></a><tt class="py-lineno">128</tt>  <tt class="py-line"> </tt>
<a name="Pg_manager.disconnect"></a><div id="Pg_manager.disconnect-def"><a name="L129"></a><tt class="py-lineno">129</tt> <a class="py-toggle" href="#" id="Pg_manager.disconnect-toggle" onclick="return toggle('Pg_manager.disconnect');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html#disconnect">disconnect</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="Pg_manager.disconnect-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Pg_manager.disconnect-expanded"><a name="L130"></a><tt class="py-lineno">130</tt>  <tt class="py-line">        <tt class="py-docstring">'''</tt> </tt>
<a name="L131"></a><tt class="py-lineno">131</tt>  <tt class="py-line"><tt class="py-docstring">        Disconnects an open database connection.</tt> </tt>
<a name="L132"></a><tt class="py-lineno">132</tt>  <tt class="py-line"><tt class="py-docstring">        '''</tt> </tt>
<a name="L133"></a><tt class="py-lineno">133</tt>  <tt class="py-line">         </tt>
<a name="L134"></a><tt class="py-lineno">134</tt>  <tt class="py-line">        <tt class="py-keyword">if</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">_con</tt><tt class="py-op">:</tt> </tt>
<a name="L135"></a><tt class="py-lineno">135</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">_con</tt><tt class="py-op">.</tt><tt class="py-name">close</tt><tt class="py-op">(</tt><tt class="py-op">)</tt>  </tt>
<a name="L136"></a><tt class="py-lineno">136</tt>  <tt class="py-line">            <tt class="py-name">self</tt><tt class="py-op">.</tt><tt class="py-name">_con</tt> <tt class="py-op">=</tt> <tt class="py-name">None</tt>   </tt>
<a name="L137"></a><tt class="py-lineno">137</tt>  <tt class="py-line">             </tt>
<a name="L138"></a><tt class="py-lineno">138</tt>  <tt class="py-line">            <tt class="py-name">logging</tt><tt class="py-op">.</tt><tt class="py-name">debug</tt><tt class="py-op">(</tt><tt class="py-string">"Pg_manager: disconnected from database"</tt><tt class="py-op">)</tt> </tt>
</div><a name="L139"></a><tt class="py-lineno">139</tt>  <tt class="py-line"> </tt>
<a name="L140"></a><tt class="py-lineno">140</tt>  <tt class="py-line">     </tt>
<a name="Pg_manager.time_str"></a><div id="Pg_manager.time_str-def"><a name="L141"></a><tt class="py-lineno">141</tt> <a class="py-toggle" href="#" id="Pg_manager.time_str-toggle" onclick="return toggle('Pg_manager.time_str');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html#time_str">time_str</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">datetime_obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="Pg_manager.time_str-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Pg_manager.time_str-expanded"><a name="L142"></a><tt class="py-lineno">142</tt>  <tt class="py-line">        <tt class="py-docstring">'''</tt> </tt>
<a name="L143"></a><tt class="py-lineno">143</tt>  <tt class="py-line"><tt class="py-docstring">        converts a given timestamp (datetime-object) to a string for a database query.</tt> </tt>
<a name="L144"></a><tt class="py-lineno">144</tt>  <tt class="py-line"><tt class="py-docstring">        </tt> </tt>
<a name="L145"></a><tt class="py-lineno">145</tt>  <tt class="py-line"><tt class="py-docstring">        @param datetime_obj: datetime object</tt> </tt>
<a name="L146"></a><tt class="py-lineno">146</tt>  <tt class="py-line"><tt class="py-docstring">        @return: timestamp as string  </tt> </tt>
<a name="L147"></a><tt class="py-lineno">147</tt>  <tt class="py-line"><tt class="py-docstring">        '''</tt> </tt>
<a name="L148"></a><tt class="py-lineno">148</tt>  <tt class="py-line">         </tt>
<a name="L149"></a><tt class="py-lineno">149</tt>  <tt class="py-line">        <tt class="py-name">time</tt> <tt class="py-op">=</tt> <tt class="py-name">psycopg2</tt><tt class="py-op">.</tt><tt class="py-name">Timestamp</tt><tt class="py-op">(</tt><tt class="py-name">datetime_obj</tt><tt class="py-op">.</tt><tt class="py-name">year</tt><tt class="py-op">,</tt>  </tt>
<a name="L150"></a><tt class="py-lineno">150</tt>  <tt class="py-line">                               <tt class="py-name">datetime_obj</tt><tt class="py-op">.</tt><tt class="py-name">month</tt><tt class="py-op">,</tt>  </tt>
<a name="L151"></a><tt class="py-lineno">151</tt>  <tt class="py-line">                               <tt class="py-name">datetime_obj</tt><tt class="py-op">.</tt><tt class="py-name">day</tt><tt class="py-op">,</tt>  </tt>
<a name="L152"></a><tt class="py-lineno">152</tt>  <tt class="py-line">                               <tt class="py-name">datetime_obj</tt><tt class="py-op">.</tt><tt class="py-name">hour</tt><tt class="py-op">,</tt>  </tt>
<a name="L153"></a><tt class="py-lineno">153</tt>  <tt class="py-line">                               <tt class="py-name">datetime_obj</tt><tt class="py-op">.</tt><tt class="py-name">minute</tt><tt class="py-op">,</tt>  </tt>
<a name="L154"></a><tt class="py-lineno">154</tt>  <tt class="py-line">                               <tt class="py-name">datetime_obj</tt><tt class="py-op">.</tt><tt class="py-name">second</tt><tt class="py-op">)</tt> </tt>
<a name="L155"></a><tt class="py-lineno">155</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">time</tt><tt class="py-op">.</tt><tt id="link-29" class="py-name"><a title="src.datastructure.agg_record.Agg_record.__str__
src.datastructure.link.Link.__str__
src.datastructure.result_value.Result_value.__str__
src.error.data_exceptions.Data_exception.__str__
src.error.exceptions.Config_exception.__str__
src.error.exceptions.Import_exception.__str__
src.error.exceptions.Indicator_exception.__str__
src.error.output_exceptions.Output_exception.__str__
src.input.db_params.DB_params.__str__" class="py-name" href="#" onclick="return doclink('link-29', '__str__', 'link-7');">__str__</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
</div><a name="L156"></a><tt class="py-lineno">156</tt>  <tt class="py-line"> </tt>
<a name="Pg_manager.date_str"></a><div id="Pg_manager.date_str-def"><a name="L157"></a><tt class="py-lineno">157</tt> <a class="py-toggle" href="#" id="Pg_manager.date_str-toggle" onclick="return toggle('Pg_manager.date_str');">-</a><tt class="py-line">    <tt class="py-keyword">def</tt> <a class="py-def-name" href="src.input.pg_manager.Pg_manager-class.html#date_str">date_str</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">date_obj</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt>
</div><div id="Pg_manager.date_str-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Pg_manager.date_str-expanded"><a name="L158"></a><tt class="py-lineno">158</tt>  <tt class="py-line">        <tt class="py-docstring">'''</tt> </tt>
<a name="L159"></a><tt class="py-lineno">159</tt>  <tt class="py-line"><tt class="py-docstring">        converts a given date to a string for a database query.</tt> </tt>
<a name="L160"></a><tt class="py-lineno">160</tt>  <tt class="py-line"><tt class="py-docstring">        </tt> </tt>
<a name="L161"></a><tt class="py-lineno">161</tt>  <tt class="py-line"><tt class="py-docstring">        @param date_obj: date object</tt> </tt>
<a name="L162"></a><tt class="py-lineno">162</tt>  <tt class="py-line"><tt class="py-docstring">        @return: timestamp as string  </tt> </tt>
<a name="L163"></a><tt class="py-lineno">163</tt>  <tt class="py-line"><tt class="py-docstring">        '''</tt> </tt>
<a name="L164"></a><tt class="py-lineno">164</tt>  <tt class="py-line"> </tt>
<a name="L165"></a><tt class="py-lineno">165</tt>  <tt class="py-line">        <tt class="py-name">date</tt> <tt class="py-op">=</tt> <tt class="py-name">psycopg2</tt><tt class="py-op">.</tt><tt class="py-name">Date</tt><tt class="py-op">(</tt><tt class="py-name">date_obj</tt><tt class="py-op">.</tt><tt class="py-name">year</tt><tt class="py-op">,</tt> </tt>
<a name="L166"></a><tt class="py-lineno">166</tt>  <tt class="py-line">                             <tt class="py-name">date_obj</tt><tt class="py-op">.</tt><tt class="py-name">month</tt><tt class="py-op">,</tt>  </tt>
<a name="L167"></a><tt class="py-lineno">167</tt>  <tt class="py-line">                             <tt class="py-name">date_obj</tt><tt class="py-op">.</tt><tt class="py-name">day</tt><tt class="py-op">)</tt> </tt>
<a name="L168"></a><tt class="py-lineno">168</tt>  <tt class="py-line">         </tt>
<a name="L169"></a><tt class="py-lineno">169</tt>  <tt class="py-line">        <tt class="py-keyword">return</tt> <tt class="py-name">date</tt><tt class="py-op">.</tt><tt id="link-30" class="py-name"><a title="src.datastructure.agg_record.Agg_record.__str__
src.datastructure.link.Link.__str__
src.datastructure.result_value.Result_value.__str__
src.error.data_exceptions.Data_exception.__str__
src.error.exceptions.Config_exception.__str__
src.error.exceptions.Import_exception.__str__
src.error.exceptions.Indicator_exception.__str__
src.error.output_exceptions.Output_exception.__str__
src.input.db_params.DB_params.__str__" class="py-name" href="#" onclick="return doclink('link-30', '__str__', 'link-7');">__str__</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt>
</div></div><a name="L170"></a><tt class="py-lineno">170</tt>  <tt class="py-line"> </tt><script type="text/javascript">
<!--
expandto(location.href);
// -->
</script>
</pre>
<br />
<!-- ==================== NAVIGATION BAR ==================== -->
<table class="navbar" border="0" width="100%" cellpadding="0"
       bgcolor="#a0c0ff" cellspacing="0">
  <tr valign="middle">
  <!-- Home link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="src-module.html">Home</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Tree link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="module-tree.html">Trees</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Index link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="identifier-index.html">Indices</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Help link -->
      <th>&nbsp;&nbsp;&nbsp;<a
        href="help.html">Help</a>&nbsp;&nbsp;&nbsp;</th>

  <!-- Project homepage -->
      <th class="navbar" align="right" width="100%">
        <table border="0" cellpadding="0" cellspacing="0">
          <tr><th class="navbar" align="center"
            >ttrq4fleet - Petrina Papazek</th>
          </tr></table></th>
  </tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" width="100%%">
  <tr>
    <td align="left" class="footer">
    Generated by Epydoc 3.0.1 on Mon Oct  8 17:34:03 2012
    </td>
    <td align="right" class="footer">
      <a target="mainFrame" href="http://epydoc.sourceforge.net"
        >http://epydoc.sourceforge.net</a>
    </td>
  </tr>
</table>

<script type="text/javascript">
  <!--
  // Private objects are initially displayed (because if
  // javascript is turned off then we want them to be
  // visible); but by default, we want to hide them.  So hide
  // them unless we have a cookie that says to show them.
  checkCookie();
  // -->
</script>
</body>
</html>
